package com.xingfly.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.xingfly.model.dto.Temp;
import com.xingfly.model.dto.User;


public interface TempDao {
	/**
	 * 查询临时表询全部
	 * @return
	 */
	public List<Temp>SelByAll()throws Exception;
	/**
	 * 两表联查
	 * @return
	 * @throws Exception
	 */
	public List<com.xingfly.suan.Temp> SelByJoinAll()throws Exception;
	
	/**
	 * 查询组id
	 * @return
	 * @throws Exception
	 */
	public int selBySERIALMax()throws Exception;
	/**
	 * 插入临时表信息
	 * @return
	 * @throws Exception
	 */
	public int insertBysatis(@Param("uid") int uid,@Param("seid") int seid,@Param("serial") int serial,@Param("satis") float satis)throws Exception;
	/**
	 * 查询出临时表中的总条数（总人数）
	 * @return
	 * @throws Exception
	 */
	public int selByCount()throws Exception;
	/**
	 * 清空临时表所有信息
	 * @return
	 * @throws Exception
	 */
	public int deleteByAll()throws Exception;
	/**
	 * 用户表和临时表关联
	 * @return
	 * @throws Exception
	 */
	public List<Temp>selByTempandusers()throws Exception;
}
